package com.onlinesys.service;

import java.sql.SQLException;
import java.util.List;

import com.onlinesys.beans.ProductStock;

public interface InWareHouseService {
    public int getProductStockTotalCount() throws SQLException;

    public List<ProductStock> getProductStocks(int startRow, int pageSize) throws SQLException;
    
    public int getProductStocksQuantitySum() throws SQLException;

    public List<ProductStock> searchProductStocks(int startRow, int pageSize, ProductStock scc) throws SQLException;
    
    public int searchProductStocksQuantitySum(ProductStock scc) throws SQLException;

    public int searchProductStocksTotalCount(ProductStock ps) throws SQLException;

    public ProductStock getProductStockById(String id) throws SQLException;
    
    public void updateProductStock(ProductStock ps, String newTicketNum, String newDrawingNum, int newQuantity) throws SQLException;
    
}
